package cn.com.api.mapper.base;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import cn.com.api.entity.ApiU_user_experence;

//DAO
public interface U_user_experenceMapperBase {

	// 根据id查看
	@Select("SELECT * FROM U_USER_EXPERENCE  WHERE ID = #{id}")
	public ApiU_user_experence findU_user_experenceById(Integer id);

	// 查看数据集
	@Select("SELECT * FROM U_user_experence")
	public List<ApiU_user_experence> findU_user_experences();

	// 添加
	@Insert("INSERT INTO U_USER_EXPERENCE (USER_ID, COMPANY, TITLE, B_TIME, E_TIME, DESCRIPTION, SORT, EXT1, EXT2, EXT3, EXT4, EXT5) VALUES (#{user_id}, #{company}, #{title}, #{b_time}, #{e_time}, #{description}, #{sort}, #{ext1}, #{ext2}, #{ext3}, #{ext4}, #{ext5})")
	@Options(useGeneratedKeys = true, keyProperty = "id")
	public int insertU_user_experence(ApiU_user_experence u_user_experence);

	// 修改
	@Update("UPDATE U_USER_EXPERENCE SET USER_ID = #{user_id}, COMPANY = #{company}, TITLE = #{title}, B_TIME = #{b_time}, E_TIME = #{e_time}, DESCRIPTION = #{description}, SORT = #{sort}, EXT1 = #{ext1}, EXT2 = #{ext2}, EXT3 = #{ext3}, EXT4 = #{ext4}, EXT5 = #{ext5} WHERE ID = #{id}")
	public int updateU_user_experence(ApiU_user_experence u_user_experence);

	// 删除
	@Delete("DELETE FROM U_USER_EXPERENCE  WHERE ID = #{id}")
	public int deleteU_user_experence(Integer id);

	// Foreign keys revelant

	// region Indexs revelant

}
